﻿CREATE TABLE [flcr].[SERVICE_CONFIG] (
    [SERVICE_CONFIG_ID]         INT           IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]                VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]                DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]             INT           NOT NULL,
    [AUDIT_MOD_USER]            VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]            DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]         INT           NOT NULL,
    [BUILTIN]                   BIT           NOT NULL,
    [WRKFL_ITEM_ID]             INT           NOT NULL,
    [WRKFL_STATUS_ID]           INT           NOT NULL,
    [ACTIVE_FLG]                BIT           NOT NULL,
    [SORT_ORDER]                INT           NOT NULL,
    [SERVICE_DEVICE_XREF_ID]    INT           NOT NULL,
    [SERVICE_CONFIG_PROP_ID]    INT           NOT NULL,
    [SERVICE_CONFIG_PROP_VALUE] VARCHAR (MAX) NOT NULL,
    [SERVICE_CONFIG_CHEKSUM]    VARCHAR (800) NOT NULL,
    [PARENT_ID]                 INT           NULL,
    [AUTOCOLLECT_FLG]           BIT           NOT NULL,
    [AUTOCOLLECT_MODULE_ID]     INT           NOT NULL,
    [AUTOCOLLECT_FDTTM]         DATETIME      NULL,
    [AUTOCOLLECT_FDTTM_TZ]      INT           NULL,
    [AUTOCOLLECT_LDTTM]         DATETIME      NULL,
    [AUTOCOLLECT_LDTTM_TZ]      INT           NULL,
    [AUTOCOLLECT_AUDIT_USER]    VARCHAR (100) NULL
);

